﻿use [clz]
-- =============================================
-- Author:		luohr
-- Description:	  添加表 ShoppingType
-- =============================================
if exists (select 1
            from  sysobjects
           where  id = object_id('ShoppingType')
            and   type = 'U')

DROP TABLE [dbo].[ShoppingType]

/*==============================================================*/
/* Table: ShoppingType                                         */
/*==============================================================*/
create table ShoppingType (
   ShoppingTypeID      int                  identity,
   ShoppingTypeName    nvarchar(50)         not null,
   constraint PK_ShoppingType primary key (ShoppingTypeID)
)

SET IDENTITY_INSERT [dbo].ShoppingType ON
INSERT [dbo].[ShoppingType] ([ShoppingTypeID], [ShoppingTypeName]) VALUES (1, N'普通购物用户')
INSERT [dbo].[ShoppingType] ([ShoppingTypeID], [ShoppingTypeName]) VALUES (2, N'视频购物用户')
SET IDENTITY_INSERT [dbo].ShoppingType OFF

